3.8 KB · ⇊ 3 parts · ⤓ Micron 3.8 KB · ⤓ HTML 20.4 KB

top

The SQL/MED ("Management of External Data") extension to the SQL standard is defined by ISO/IEC 9075-9:2008 (originally defined for SQL:2003). SQL/MED provides extensions to SQL that define foreign-data wrappers and datalink types to allow SQL to manage external data. External data is data that is accessible to, but not managed by, an SQL-based DBMS. This standard can be used in the development of federated database systems.

• Implementations

• See also

• References

• External links

• PostgreSQL has support for some SQL/MED since version 9.1.cite-ref-1[1]cite-ref-2[2]

• LucidDB has support for SQL/MED.cite-ref-3[3]

• MariaDB has support for SQL/MED with the CONNECT storage engine.cite-ref-4[4] The implementation uses different syntax than the official standard.

• Farrago has support for SQL/MED.cite-ref-5[5]

• IBM Db2 has support for SQL/MED.cite-ref-6[6]

• Teiid has support for SQL/MED. cite-ref-7[7]

• Microsoft SQL Server has internal support for SQL/MED. DATALINK is provided by the FILESTREAMcite-ref-8[8] (SQL Server 2008) and FileTable (SQL Server 2012) functionnalities and external data wrapper by the EXTERNAL TABLEs and PolyBasecite-ref-9[9]

• SQL

• SQL:2008

• SQL:2003

cite-note-11. ↑ PostgreSQL Wiki: SQL/MED

cite-note-22. ↑ Chapter 5.12, "Foreign Data" of the PostgreSQL Guide.

cite-note-33. ↑ LucidDB Architecture

cite-note-44. ↑ CONNECT storage engine

cite-note-55. ↑ Farrago SQL/MED Support

cite-note-66. ↑ IBM federated database technology

cite-note-77. ↑ Teiid Documentation

cite-note-88. ↑ FILESTREAM

cite-note-99. ↑ EXTERNAL TABLE / PolyBase

• SQL/MED - A Status Report